/****** Object:  Stored Procedure [dbo].spChiTietBienBanNhapHangInsert Script Date: 7/16/2012 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[spChiTietBienBanNhapHangInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[spChiTietBienBanNhapHangInsert]
GO

/******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:					Description:
**		--------	--------				-----------------------------------
**		17/07/2012	SongTM					Innit created
*******************************************************************************/

CREATE PROCEDURE [dbo].[spChiTietBienBanNhapHangInsert]
(
	@MaBBNH nvarchar(12),
	@MaCTPN nvarchar(12),
	@ThucTe int,
	@Thua int,
	@Thieu int,
	@Hong int,
	@TinhTrang nvarchar(50),
	@GhiChu nvarchar(200)
)
WITH ENCRYPTION

AS

SET NOCOUNT ON

INSERT INTO [tbl_ChiTietBienBanNhapHang]
(
	[MaBBNH],
	[MaCTPN],
	[ThucTe],
	[Thua],
	[Thieu],
	[Hong],
	[TinhTrang],
	[GhiChu]
)
VALUES
(
	@MaBBNH,
	@MaCTPN,
	@ThucTe,
	@Thua,
	@Thieu,
	@Hong,
	@TinhTrang,
	@GhiChu
)
GO

--GRANT EXECUTE ON [dbo].[spChiTietBienBanNhapHangInsert] TO [sa]
--GO
